home *** CD-ROM | disk | FTP | other *** search
/ United Public Domain Gold 2 / United Public Domain Gold 2.iso / business / pb031.dms / pb031.adf / EasyCalc / WorkSheets / Example1 (.txt) < prev    next >
EasyCalc Spreadsheet file  |  1992-11-20  |  2KB  |  71 lines
  1. EASY10
  2. B'This worksheet demonstrates all the EasyCalc functions available:
  3. "Range to work on:
  4. "Total:
  5.     "Average:
  6. "Minimum value:
  7. "Maximum value:
  8. "'All the standard maths operators:
  9. "10 + 2
  10. "10 - 2
  11. "10 * 2
  12. "10 / 2
  13. "10 ^ 2
  14. "10 <> 5
  15. "10 = 5
  16. "10 >= 5
  17. "10 <= 5
  18. "10 > 5
  19. "10 < 5
  20. =@sum(A4:A7)
  21. =@avg(A4:A7)
  22. =@min(A4:A7)
  23. =@max(A4:A7)
  24. =10+2
  25. =10-2
  26. =10*2
  27. =10/2
  28. =10^2
  29. =10<>5
  30. =10=5
  31. =10>=5
  32. =10<=5
  33. =10>5
  34. =10<5
  35. "Functions:
  36.     "abs(1.2)
  37.     "atn(1.2)
  38. "cint(1.2)
  39.     "cos(1.2)
  40.     "deg(1.2)
  41.     "exp(1.2)
  42.     "fix(1.2)
  43.     "int(1.2)
  44.     "log(1.2)
  45.     "rnd(150)
  46.     "rad(300)
  47.     "sign(-3)
  48.     "sin(1.2)
  49. "sqr(49)
  50.     "tan(1.2)
  51. "vat(399.95)
  52. "Conditionals:
  53. "IF 5<15, 1 ELSE 0
  54. =@abs(1.2)
  55. =@atn(1.2)
  56. =@cint(1.2)
  57. =@cos(1.2)
  58. =@deg(1.2)
  59. =@exp(1.2)
  60. =@fix(1.2)
  61. =@int(1.2)
  62. =@log(1.2)
  63. =@rnd(150)
  64. =@rad(300)
  65. =@sign(-3)
  66. =@sin(1.2)
  67. C    =@sqr(49)
  68. =@tan(1.2)
  69. =@vat(399.95)
  70. =@if(5<15,1,0)
  71.